Release 10.1A: OpenEdge Deployment:
Startup Command and Parameter Reference


Base Index (-baseindex)

Use Base Index (-baseindex) with Index Range Size (-indexrangesize) to specify the range of indexes for which you want to collect statistics.

Operating system
and syntax
UNIX
Windows
-baseindex n
Use
with
Maximum value
Minimum value
Single-user default
Multi-user default
Database Server

n

The starting index number in the range of indexes for which you want to track access statistics.

Access to the statistics is handled through the Virtual System Tables (VSTs). Index statistics are stored in the _IndexStat VST. To obtain index numbers, use the following 4GL code:

FOR EACH _file:
     DISPLAY _file.file-filename.
     FOR EACH _index WHERE index.file-recid = RECID(file):
           DISPLAY _idx-num _index-name.
     END.
END. 

This results in the following output:

File-Name
filename

_idx-num Index-Name
     n1   index name1
     n2   index name2
     n3   index name3 

For more information on virtual system tables, see OpenEdge Data Management: Database Administration .


Copyright © 2005 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095